USE [AMS]
GO

/****** Object:  StoredProcedure [dbo].[UpdateAnalysisMethod]    Script Date: 03/01/2010 19:00:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Johan Celis
-- Create date: 2 January 2010
-- Description:	
-- Change Date: 1/3/2010
-- Description: vertaalvelden toegevoegd
-- Change date: 30/04/2010
-- Description: link met AnalysisMethodGroup tabel
-- =============================================
ALTER PROCEDURE [dbo].[UpdateAnalysisMethod] 
	@Group INT,
	@ID INT,
	@Name VARCHAR(50),
	@NameFR VARCHAR(50),
	@NameEN VARCHAR(50),
	@NameDE VARCHAR(50),
	@Version VARCHAR(50),
	@Active BIT
AS
BEGIN
	UPDATE AnalysisMethod
	SET AnalysisMethodName = @Name,
	AnalysisMethodNameFR = @NameFR,
	AnalysisMethodNameDE = @NameDE,
	AnalysisMethodNameEN = @NameEN,
	AnalysisMethodScientificVersion = @Version,
	Active = @Active,
	AnalysisMethodGroupID_FK = @Group
	WHERE AnalysisMethodID = @ID
END

GO

